SET QUOTED_IDENTIFIER OFF;
GO
USE [image];
GO
insert into category values ('Architecture');
insert into category values ('Art');
insert into category values ('Cars & Motorcycles');
insert into category values ('Design');
insert into category values ('DIY & Crafts');
insert into category values ('Education');
insert into category values ('Film, Music & Books');
insert into category values ('Fitness');
insert into category values ('Food & Drink');
insert into category values ('Gardening');
insert into category values ('Geek');
insert into category values ('Hair & Beauty');
insert into category values ('History');
insert into category values ('Holidays');
insert into category values ('Home Decor');
insert into category values ('Humor');
insert into category values ('Kids');
insert into category values ('My Life');
insert into category values ('Women''s Apparel');
insert into category values ('Men''s Apparel');
insert into category values ('Outdoors');
insert into category values ('People');
insert into category values ('Pets');
insert into category values ('Photography');
insert into category values ('Print & Posters');
insert into category values ('Products');
insert into category values ('Science & Nature');
insert into category values ('Sports');
insert into category values ('Technology');
insert into category values ('Travel & Places');
insert into category values ('Wedding & Events');
insert into category values ('Other');
insert into registereduser values ('paul.zeigenfuss@gmail.com', 'test', 'Paul', 'Paul', 'Zeigenfuss','27-MAR-2012');
insert into registereduser values ('paul_zeigenfuss@gmail.com', 'test', 'PZiggy', 'Paul', 'Zeigenfuss','27-MAR-2012');
insert into registereduser values ('pdz100@psu.edu', 'test', 'Spindlewhirl', 'Paul', 'Zeigenfuss','27-MAR-2012');
insert into registereduser values ('dawnmberry777@gmail.com', 'test', 'Dawn', 'Dawn', 'Berry','27-MAR-2012');
insert into registereduser values ('kksengha@gmail.com', 'test', 'Kal', 'Kal', 'Sengha','27-MAR-2012');
/**please do not do this here do it with hard coded ratingid so identity is certain correct
insert into rating values ('lowest rating out of 1 thru 5');
insert into rating values ('2nd place rating');
insert into rating values ('3d place rating');
insert into rating values ('4th place rating');
insert into rating values ('highest, most favorable rating, 5');
**/



